package cc.autoapi.pucong.liteflow.design.utils;

/**
 * sql 读取常量类
 *
 * @author tangkc
 * @author houxinyu
 * @author Bryan.Zhang
 * @since 2.11.1
 */
public class SqlConstant {

    public static final String CHECK_SQL_PATTERN = "SELECT {},{} FROM {}";

    public static final String SQL_PATTERN_KEYWORD = "SELECT * FROM {} WHERE {} like ? or {} like ? ";
    public static final String SQL_PATTERN = "SELECT * FROM {} ";
    public static final String SQL_PATTERN_ID = "SELECT * FROM {} WHERE {} = ? ";
    public static final String SQL_INSERT = "INSERT INTO {}({},{},{},{}) VALUES(?,?,?,?) ";
    public static final String SQL_INSERT_AUTO = "INSERT INTO {}({},{},{}) VALUES(?,?,?) ";
    public static final String SQL_UPDATE = "UPDATE {} set {} = ?,{} = ?,{} = ? where {} = ? ";
    public static final String SQL_UPDATE_ONE = "UPDATE {} set {} = ? where {} = ?  ";
    public static final String SQL_DELETE = "DELETE FROM {} where {} = ?  ";
    public static final String SQL_NODE_INSERT = "INSERT INTO {}({},{},{},{},{},{},{}) VALUES(?,?,?,?,?,?,?) ";
    public static final String SQL_NODE_INSERT_AUTO = "INSERT INTO {}({},{},{},{},{},{}) VALUES(?,?,?,?,?,?) ";
    public static final String SQL_NODE_UPDATE = "UPDATE {} set {} = ?,{} = ?,{} = ?,{} = ?,{} = ? where {} = ? ";

}
